﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="AppDataSet" targetNamespace="http://tempuri.org/AppDataSet.xsd" xmlns:mstns="http://tempuri.org/AppDataSet.xsd" xmlns="http://tempuri.org/AppDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="DL_TestConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="DL_TestConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.CheckGUID.Properties.Settings.GlobalReference.Default.DL_TestConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblsecnovelluserTableAdapter" GeneratorDataComponentClassName="tblsecnovelluserTableAdapter" Name="tblsecnovelluser" UserDataComponentName="tblsecnovelluserTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DL_TestConnectionString (Settings)" DbObjectName="DL_Test.dbo.tblsecnovelluser" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblsecnovelluser] ([vcUserName], [chstaffcode], [vcAltUserName], [vcADUserName]) VALUES (@vcUserName, @chstaffcode, @vcAltUserName, @vcADUserName)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@vcUserName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="vcUserName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@chstaffcode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="chstaffcode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@vcAltUserName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="vcAltUserName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@vcADUserName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="vcADUserName" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT vcUserName, chstaffcode, vcAltUserName, vcADUserName FROM dbo.tblsecnovelluser</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="vcUserName" DataSetColumn="vcUserName" />
              <Mapping SourceColumn="chstaffcode" DataSetColumn="chstaffcode" />
              <Mapping SourceColumn="vcAltUserName" DataSetColumn="vcAltUserName" />
              <Mapping SourceColumn="vcADUserName" DataSetColumn="vcADUserName" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblstaffTableAdapter" GeneratorDataComponentClassName="tblstaffTableAdapter" Name="tblstaff" UserDataComponentName="tblstaffTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DL_TestConnectionString (Settings)" DbObjectName="DL_Test.dbo.tblstaff" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblstaff] ([chstaffcode], [vcStaffName], [vcAltUserName], [sdStaffTermDate], [chCurrOfficeCode], [vcFirstname], [vcSurName]) VALUES (@chstaffcode, @vcStaffName, @vcAltUserName, @sdStaffTermDate, @chCurrOfficeCode, @vcFirstname, @vcSurName)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@chstaffcode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="chstaffcode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@vcStaffName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="vcStaffName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@vcAltUserName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="vcAltUserName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@sdStaffTermDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="sdStaffTermDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@chCurrOfficeCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="chCurrOfficeCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@vcFirstname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="vcFirstname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@vcSurName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="vcSurName" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT chstaffcode, vcStaffName, vcAltUserName, sdStaffTermDate, chCurrOfficeCode, vcFirstname, vcSurName FROM dbo.tblstaff</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="chstaffcode" DataSetColumn="chstaffcode" />
              <Mapping SourceColumn="vcStaffName" DataSetColumn="vcStaffName" />
              <Mapping SourceColumn="vcAltUserName" DataSetColumn="vcAltUserName" />
              <Mapping SourceColumn="sdStaffTermDate" DataSetColumn="sdStaffTermDate" />
              <Mapping SourceColumn="chCurrOfficeCode" DataSetColumn="chCurrOfficeCode" />
              <Mapping SourceColumn="vcFirstname" DataSetColumn="vcFirstname" />
              <Mapping SourceColumn="vcSurName" DataSetColumn="vcSurName" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblStaffLoATableAdapter" GeneratorDataComponentClassName="tblStaffLoATableAdapter" Name="tblStaffLoA" UserDataComponentName="tblStaffLoATableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DL_TestConnectionString (Settings)" DbObjectName="DL_Test.dbo.tblStaffLoA" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblStaffLoA] ([chstaffcode], [sdLoaStartDate], [sdLoaEndDate]) VALUES (@chstaffcode, @sdLoaStartDate, @sdLoaEndDate)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@chstaffcode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="chstaffcode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@sdLoaStartDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="sdLoaStartDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@sdLoaEndDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="sdLoaEndDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT chstaffcode, sdLoaStartDate, sdLoaEndDate FROM dbo.tblStaffLoA</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="chstaffcode" DataSetColumn="chstaffcode" />
              <Mapping SourceColumn="sdLoaStartDate" DataSetColumn="sdLoaStartDate" />
              <Mapping SourceColumn="sdLoaEndDate" DataSetColumn="sdLoaEndDate" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AppUsersNeedingGuidCheckTableAdapter" GeneratorDataComponentClassName="AppUsersNeedingGuidCheckTableAdapter" Name="AppUsersNeedingGuidCheck" UserDataComponentName="AppUsersNeedingGuidCheckTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DL_TestConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>select s.chstaffcode, s.vcStaffName, s.vcAltuserName StaffGUID, s.sdStaffTermDate, s.chCurrOfficeCode,
 upper(nu.vcUserName) vcUsername, s.vcFirstname+' '+s.vcSurName StaffName, 
 nu.vcAltUserName NSUGUID, nu.vcADUserName, 
 max(sloa.sdLoaStartDate) MaxsloaStartDate, max(sloa.sdLoaEndDate) MaxsdLoaEndDate
-- select top 200 *
from tblstaff s (nolock)
left join tblsecnovelluser nu (nolock)
 on s.chstaffcode = nu.chstaffcode
 and upper(nu.vcUserName) = s.vcFirstname+' '+s.vcSurName
left join tblStaffLoA sloa (nolock)
 on sloa.chstaffcode = s.chstaffcode
where s.vcAltUsername &lt;&gt; nu.vcAltUserName
 and sdLoaEndDate is not NULL        -- DO 2 SQL - 1 null one not null
 --and s.chCurrGroupCode between 100 and 199 -- AAG
 and s.sdStaffTermDAte is NULL
--and s.chCurrOfficeCode = 'HL1'
group by s.chstaffcode, s.vcStaffName, s.vcAltuserName, s.sdStaffTermDate, s.chCurrOfficeCode,
 nu.vcUserName, s.vcFirstname+' '+s.vcSurName, nu.vcAltUserName, nu.vcADUserName--, sloa.sdLoaEndDate
having max(sloa.sdLoaEndDate)  &gt;= '01 Sep 2009'
order by maxsdloaenddate desc -- nu.vcUsername</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="chstaffcode" DataSetColumn="chstaffcode" />
              <Mapping SourceColumn="vcStaffName" DataSetColumn="vcStaffName" />
              <Mapping SourceColumn="StaffGUID" DataSetColumn="StaffGUID" />
              <Mapping SourceColumn="sdStaffTermDate" DataSetColumn="sdStaffTermDate" />
              <Mapping SourceColumn="chCurrOfficeCode" DataSetColumn="chCurrOfficeCode" />
              <Mapping SourceColumn="vcUsername" DataSetColumn="vcUsername" />
              <Mapping SourceColumn="StaffName" DataSetColumn="StaffName" />
              <Mapping SourceColumn="NSUGUID" DataSetColumn="NSUGUID" />
              <Mapping SourceColumn="vcADUserName" DataSetColumn="vcADUserName" />
              <Mapping SourceColumn="MaxsloaStartDate" DataSetColumn="MaxsloaStartDate" />
              <Mapping SourceColumn="MaxsdLoaEndDate" DataSetColumn="MaxsdLoaEndDate" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="AppDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="AppDataSet" msprop:Generator_DataSetName="AppDataSet" msprop:EnableTableAdapterManager="True">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="tblsecnovelluser" msprop:Generator_UserTableName="tblsecnovelluser" msprop:Generator_RowDeletedName="tblsecnovelluserRowDeleted" msprop:Generator_RowChangedName="tblsecnovelluserRowChanged" msprop:Generator_RowClassName="tblsecnovelluserRow" msprop:Generator_RowChangingName="tblsecnovelluserRowChanging" msprop:Generator_RowEvArgName="tblsecnovelluserRowChangeEvent" msprop:Generator_RowEvHandlerName="tblsecnovelluserRowChangeEventHandler" msprop:Generator_TableClassName="tblsecnovelluserDataTable" msprop:Generator_TableVarName="tabletblsecnovelluser" msprop:Generator_RowDeletingName="tblsecnovelluserRowDeleting" msprop:Generator_TablePropName="tblsecnovelluser">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="vcUserName" msprop:Generator_UserColumnName="vcUserName" msprop:Generator_ColumnPropNameInRow="vcUserName" msprop:Generator_ColumnVarNameInTable="columnvcUserName" msprop:Generator_ColumnPropNameInTable="vcUserNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="chstaffcode" msprop:Generator_UserColumnName="chstaffcode" msprop:Generator_ColumnPropNameInRow="chstaffcode" msprop:Generator_ColumnVarNameInTable="columnchstaffcode" msprop:Generator_ColumnPropNameInTable="chstaffcodeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="vcAltUserName" msprop:Generator_UserColumnName="vcAltUserName" msprop:Generator_ColumnPropNameInRow="vcAltUserName" msprop:Generator_ColumnVarNameInTable="columnvcAltUserName" msprop:Generator_ColumnPropNameInTable="vcAltUserNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="vcADUserName" msprop:Generator_UserColumnName="vcADUserName" msprop:Generator_ColumnPropNameInRow="vcADUserName" msprop:Generator_ColumnVarNameInTable="columnvcADUserName" msprop:Generator_ColumnPropNameInTable="vcADUserNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblstaff" msprop:Generator_UserTableName="tblstaff" msprop:Generator_RowDeletedName="tblstaffRowDeleted" msprop:Generator_RowChangedName="tblstaffRowChanged" msprop:Generator_RowClassName="tblstaffRow" msprop:Generator_RowChangingName="tblstaffRowChanging" msprop:Generator_RowEvArgName="tblstaffRowChangeEvent" msprop:Generator_RowEvHandlerName="tblstaffRowChangeEventHandler" msprop:Generator_TableClassName="tblstaffDataTable" msprop:Generator_TableVarName="tabletblstaff" msprop:Generator_RowDeletingName="tblstaffRowDeleting" msprop:Generator_TablePropName="tblstaff">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="chstaffcode" msprop:Generator_UserColumnName="chstaffcode" msprop:Generator_ColumnPropNameInRow="chstaffcode" msprop:Generator_ColumnVarNameInTable="columnchstaffcode" msprop:Generator_ColumnPropNameInTable="chstaffcodeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="vcStaffName" msprop:Generator_UserColumnName="vcStaffName" msprop:Generator_ColumnPropNameInRow="vcStaffName" msprop:Generator_ColumnVarNameInTable="columnvcStaffName" msprop:Generator_ColumnPropNameInTable="vcStaffNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="vcAltUserName" msprop:Generator_UserColumnName="vcAltUserName" msprop:Generator_ColumnPropNameInRow="vcAltUserName" msprop:Generator_ColumnVarNameInTable="columnvcAltUserName" msprop:Generator_ColumnPropNameInTable="vcAltUserNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sdStaffTermDate" msprop:Generator_UserColumnName="sdStaffTermDate" msprop:Generator_ColumnPropNameInRow="sdStaffTermDate" msprop:Generator_ColumnVarNameInTable="columnsdStaffTermDate" msprop:Generator_ColumnPropNameInTable="sdStaffTermDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="chCurrOfficeCode" msprop:Generator_UserColumnName="chCurrOfficeCode" msprop:Generator_ColumnPropNameInRow="chCurrOfficeCode" msprop:Generator_ColumnVarNameInTable="columnchCurrOfficeCode" msprop:Generator_ColumnPropNameInTable="chCurrOfficeCodeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="vcFirstname" msprop:Generator_UserColumnName="vcFirstname" msprop:Generator_ColumnPropNameInRow="vcFirstname" msprop:Generator_ColumnVarNameInTable="columnvcFirstname" msprop:Generator_ColumnPropNameInTable="vcFirstnameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="vcSurName" msprop:Generator_UserColumnName="vcSurName" msprop:Generator_ColumnPropNameInRow="vcSurName" msprop:Generator_ColumnVarNameInTable="columnvcSurName" msprop:Generator_ColumnPropNameInTable="vcSurNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblStaffLoA" msprop:Generator_UserTableName="tblStaffLoA" msprop:Generator_RowDeletedName="tblStaffLoARowDeleted" msprop:Generator_RowChangedName="tblStaffLoARowChanged" msprop:Generator_RowClassName="tblStaffLoARow" msprop:Generator_RowChangingName="tblStaffLoARowChanging" msprop:Generator_RowEvArgName="tblStaffLoARowChangeEvent" msprop:Generator_RowEvHandlerName="tblStaffLoARowChangeEventHandler" msprop:Generator_TableClassName="tblStaffLoADataTable" msprop:Generator_TableVarName="tabletblStaffLoA" msprop:Generator_RowDeletingName="tblStaffLoARowDeleting" msprop:Generator_TablePropName="tblStaffLoA">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="chstaffcode" msprop:Generator_UserColumnName="chstaffcode" msprop:Generator_ColumnPropNameInRow="chstaffcode" msprop:Generator_ColumnVarNameInTable="columnchstaffcode" msprop:Generator_ColumnPropNameInTable="chstaffcodeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sdLoaStartDate" msprop:Generator_UserColumnName="sdLoaStartDate" msprop:Generator_ColumnPropNameInRow="sdLoaStartDate" msprop:Generator_ColumnVarNameInTable="columnsdLoaStartDate" msprop:Generator_ColumnPropNameInTable="sdLoaStartDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="sdLoaEndDate" msprop:Generator_UserColumnName="sdLoaEndDate" msprop:Generator_ColumnPropNameInRow="sdLoaEndDate" msprop:Generator_ColumnVarNameInTable="columnsdLoaEndDate" msprop:Generator_ColumnPropNameInTable="sdLoaEndDateColumn" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="AppUsersNeedingGuidCheck" msprop:Generator_UserTableName="AppUsersNeedingGuidCheck" msprop:Generator_RowDeletedName="AppUsersNeedingGuidCheckRowDeleted" msprop:Generator_RowChangedName="AppUsersNeedingGuidCheckRowChanged" msprop:Generator_RowClassName="AppUsersNeedingGuidCheckRow" msprop:Generator_RowChangingName="AppUsersNeedingGuidCheckRowChanging" msprop:Generator_RowEvArgName="AppUsersNeedingGuidCheckRowChangeEvent" msprop:Generator_RowEvHandlerName="AppUsersNeedingGuidCheckRowChangeEventHandler" msprop:Generator_TableClassName="AppUsersNeedingGuidCheckDataTable" msprop:Generator_TableVarName="tableAppUsersNeedingGuidCheck" msprop:Generator_RowDeletingName="AppUsersNeedingGuidCheckRowDeleting" msprop:Generator_TablePropName="AppUsersNeedingGuidCheck">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="chstaffcode" msprop:Generator_UserColumnName="chstaffcode" msprop:Generator_ColumnVarNameInTable="columnchstaffcode" msprop:Generator_ColumnPropNameInRow="chstaffcode" msprop:Generator_ColumnPropNameInTable="chstaffcodeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="vcStaffName" msprop:Generator_UserColumnName="vcStaffName" msprop:Generator_ColumnVarNameInTable="columnvcStaffName" msprop:Generator_ColumnPropNameInRow="vcStaffName" msprop:Generator_ColumnPropNameInTable="vcStaffNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StaffGUID" msprop:Generator_UserColumnName="StaffGUID" msprop:Generator_ColumnVarNameInTable="columnStaffGUID" msprop:Generator_ColumnPropNameInRow="StaffGUID" msprop:Generator_ColumnPropNameInTable="StaffGUIDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sdStaffTermDate" msprop:Generator_UserColumnName="sdStaffTermDate" msprop:Generator_ColumnVarNameInTable="columnsdStaffTermDate" msprop:Generator_ColumnPropNameInRow="sdStaffTermDate" msprop:Generator_ColumnPropNameInTable="sdStaffTermDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="chCurrOfficeCode" msprop:Generator_UserColumnName="chCurrOfficeCode" msprop:Generator_ColumnVarNameInTable="columnchCurrOfficeCode" msprop:Generator_ColumnPropNameInRow="chCurrOfficeCode" msprop:Generator_ColumnPropNameInTable="chCurrOfficeCodeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="vcUsername" msdata:ReadOnly="true" msprop:Generator_UserColumnName="vcUsername" msprop:Generator_ColumnVarNameInTable="columnvcUsername" msprop:Generator_ColumnPropNameInRow="vcUsername" msprop:Generator_ColumnPropNameInTable="vcUsernameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StaffName" msdata:ReadOnly="true" msprop:Generator_UserColumnName="StaffName" msprop:Generator_ColumnVarNameInTable="columnStaffName" msprop:Generator_ColumnPropNameInRow="StaffName" msprop:Generator_ColumnPropNameInTable="StaffNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="101" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NSUGUID" msprop:Generator_UserColumnName="NSUGUID" msprop:Generator_ColumnVarNameInTable="columnNSUGUID" msprop:Generator_ColumnPropNameInRow="NSUGUID" msprop:Generator_ColumnPropNameInTable="NSUGUIDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="vcADUserName" msprop:Generator_UserColumnName="vcADUserName" msprop:Generator_ColumnVarNameInTable="columnvcADUserName" msprop:Generator_ColumnPropNameInRow="vcADUserName" msprop:Generator_ColumnPropNameInTable="vcADUserNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MaxsloaStartDate" msdata:ReadOnly="true" msprop:Generator_UserColumnName="MaxsloaStartDate" msprop:Generator_ColumnVarNameInTable="columnMaxsloaStartDate" msprop:Generator_ColumnPropNameInRow="MaxsloaStartDate" msprop:Generator_ColumnPropNameInTable="MaxsloaStartDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="MaxsdLoaEndDate" msdata:ReadOnly="true" msprop:Generator_UserColumnName="MaxsdLoaEndDate" msprop:Generator_ColumnVarNameInTable="columnMaxsdLoaEndDate" msprop:Generator_ColumnPropNameInRow="MaxsdLoaEndDate" msprop:Generator_ColumnPropNameInTable="MaxsdLoaEndDateColumn" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ErrorTable" msprop:Generator_UserTableName="ErrorTable" msprop:Generator_RowDeletedName="ErrorTableRowDeleted" msprop:Generator_TableClassName="ErrorTableDataTable" msprop:Generator_RowChangedName="ErrorTableRowChanged" msprop:Generator_RowClassName="ErrorTableRow" msprop:Generator_RowChangingName="ErrorTableRowChanging" msprop:Generator_RowEvArgName="ErrorTableRowChangeEvent" msprop:Generator_RowEvHandlerName="ErrorTableRowChangeEventHandler" msprop:Generator_TablePropName="ErrorTable" msprop:Generator_TableVarName="tableErrorTable" msprop:Generator_RowDeletingName="ErrorTableRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ErrorID" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="ErrorID" msprop:Generator_ColumnPropNameInRow="ErrorID" msprop:Generator_ColumnVarNameInTable="columnErrorID" msprop:Generator_ColumnPropNameInTable="ErrorIDColumn" type="xs:int" />
              <xs:element name="Message" msprop:Generator_UserColumnName="Message" msprop:nullValue="_null" msprop:Generator_ColumnVarNameInTable="columnMessage" msprop:Generator_ColumnPropNameInTable="MessageColumn" msprop:Generator_ColumnPropNameInRow="Message" type="xs:string" minOccurs="0" />
              <xs:element name="Stacktrace" msprop:Generator_UserColumnName="Stacktrace" msprop:nullValue="_null" msprop:Generator_ColumnVarNameInTable="columnStacktrace" msprop:Generator_ColumnPropNameInTable="StacktraceColumn" msprop:Generator_ColumnPropNameInRow="Stacktrace" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
  </xs:element>
</xs:schema>